3 visuals for webpage

This code will help produce the three visuals that are going to be a part of each equity tracker indicator webpage: regional map (tract level) of most recent data, chart of the most recent data, chart of trends over time.

If the indicator is a PUMS/OPSI indicator that can be accessed through Elmer. Getting the data to a workable version may require some data transformation. To explore, clean, transform, and generate a final data set, please use the data-gen-pums-template. This script will generate an .rda for the map and an .rda for the charts. These data sets will be loaded in before the data visualization code.

Indicator Explanation

[Kindergarten readiness is an important and early predictor of high school graduation. Recognizing the effectiveness and importance of the first five years of life, there have been recent efforts to strengthen early childhood programs in Washington state and the region. Readiness for incoming kindergarteners in Washington is assessed by teachers who observe students across six areas of development and learning: social emotional, physical, language, cognitive, literacy and math. For this measure, we are defining students as kindergarten ready if they demonstrate readiness in all six areas.]

1. Map of most recent data

To map data in this form, it requires accessing the most recent data from OSPI since the Elmer data set is already aggregated to equity group/quintile.

Create Visual

Sources: Washington Office of Superintendent of Public Instruction (OSPI) 2022-23 Washington Kindergarten Inventory of Developing Skills (WaKIDS); U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles



Data call outs

  1. 53%: The percentage of students ready for kindergarten in the region
  2. 81%: Snoqualmie Valley School District (King County) has the highest percentage of students ready for kindergarten
  3. 40%: Percentage point difference between school district with highest proportion of kindergarten ready students and one with lowest


Insights & Analysis

  • King County has the highest proportion of students who are kindergarten ready (59%), followed by Kitsap (52%), Pierce (47%), and Snohomish (46%)
  • Of the 37,800 kindergarten students in the four-county region, almost half of them are in King County (49%), one-quarter are in Pierce (25%), one-fifth are in Snohomish (20%), and the remaining are in Kitsap (6%)
  • There are 6 school districts that overlap 2 counties, 3 of which are both in the PSRC region: Auburn School District (King and Pierce), Fife School District (King and Pierce), and Northshore School District (King and Snohomish); and 3 extend outside the region: Darrington School District (Skagit and Snohomish), Eatonville School District (Lewis and Pierce), and Stanwood-Camano School District (Island and Snohomish)
  • Index School District (Snohomish County) and Skykomish School District (King County) are the only two districts with suppressed data



2. Facet of most recent data

Create Visual

Kindergarten Readiness

Percent of students demonstrating readiness in 6 of 6 domains*

Washington Office of Superintendent of Public Instruction (OSPI) 2022-23 Washington Kindergarten Inventory of Developing Skills (WaKIDS)
No data available for students with limited English proficiency in Kitsap County
*Social-Emotional, Physical, Language, Cognitive, Literacy, and Math

Data call outs

  1. 37%: The percentage of students from households below 200% of the poverty level who are kindergarten ready
  2. 33%: In 2022, the percentage of students ready for kindergarten was 33% lower for students with disabilities
  3. 11%: In 2022, fewer students of color were ready for kindergarten than their white non-Hispanic counterparts, a difference of 11%


Insights & Analysis

  • The smallest difference in kindergarten readiness between students of color and white non-Hispanic students is in Kitsap County (3%), while the largest difference is in King County (16%) - Pierce (11%) and Snohomish (9%) fall in the middle
  • For students who belong to households below 200% of the poverty level, kindergarten readiness is lowest in Snohomish County (32%), followed by Pierce (37%), King (38%), and Kitsap (48%)
  • The largest difference in kindergarten readiness between students with and without a disability is in King County (37%), while the smallest difference is in Kitsap and Pierce Counties (28%)
  • Available data are too limited to accurately report kindergarten readiness for limited English proficient students in Kitsap County



3. Facet of trend data

Create Visual

Kindergarten Readiness

Percent of students demonstrating readiness in 6 of 6 domains*

Washington Office of Superintendent of Public Instruction (OSPI) 2021-23 Washington Kindergarten Inventory of Developing Skills (WaKIDS)
Limited data available for students with limited English proficiency in Kitsap County
No data available for school year 2020-21
*Social-Emotional, Physical, Language, Cognitive, Literacy, and Math

Data call outs

  1. 10%: Students of color are less likely to be prepared for kindergarten compared to white non-Hispanic students, a gap of 10% and a decrease of 48% over the past decade
  2. 24%: The gap in kindergarten readiness between students from low-income households and non-low income households has remained relatively consistent in the last ten years, decreasing from 27% in 2011 to 24% in 2022
  3. 47%: Students with disabilities are less likely to be prepared for kindergarten compared to students without disabilities, a gap which has increased by 47% over time


Insights & Analysis

  • The difference in kindergarten readiness between students of color and white non-Hispanic over time has decreased regionally (-48%), with the most noticeable increase in in Snohomish County (+13%) and the most noticeable decrease in King County (-21%)
  • The percentage of students prepared for kindergarten decreased over the past decade for all groups in Pierce and Snohomish Counties, while kindergarten readiness seemed in increase for all groups in King County.
  • In King County, the difference in kindergarten readiness between students with and without a disability almost doubled over the past decade (+95%), while the difference slightly increased in Snohomish County (4%) and decreased in Pierce County (-10%). Kitsap County didn’t report data for students with disabilities until 2015 and in the past half decade, the difference has decreased slightly (-7%)



Transfer files

Copy files from Github > Y drive

Copy files from Y drive > website folder

Back to top of the page